# snppt db schema
DROP TABLE IF EXISTS `posts`;

CREATE TABLE `posts` (
  `uid` varchar(100) NOT NULL,
  `authorname` varchar(255) NOT NULL default '',
  `post` text NOT NULL,
  `parent` varchar(100) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `authoremail` varchar(100) NOT NULL default '',
  UNIQUE KEY `UNIQUE` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `posts` (`uid`,`authorname`,`post`,`parent`,`created`,`authoremail`) VALUES ('2360500969','jasonhuck','define_tag(\'foo\'); return(\'bar\'); /define_tag;','','2008-07-06 07:27:45','jason.huck@gmail.com');
INSERT INTO `posts` (`uid`,`authorname`,`post`,`parent`,`created`,`authoremail`) VALUES ('278306538','jasonhuck','// added some whitespace\r\ndefine_tag(\'foo\');\r\n	return(\'bar\');\r\n/define_tag;\r\n			','2360500969','2008-07-06 08:10:25','jason.huck@gmail.com');
INSERT INTO `posts` (`uid`,`authorname`,`post`,`parent`,`created`,`authoremail`) VALUES ('3877714930','jasonhuck','// added some whitespace\r\ndefine_tag(\'foo\', -encodenone);\r\n	return(\'bar\');\r\n/define_tag;		\r\n		','278306538','2008-07-06 08:13:51','jason.huck@gmail.com');
INSERT INTO `posts` (`uid`,`authorname`,`post`,`parent`,`created`,`authoremail`) VALUES ('1143694490','jasonhuck','// added some whitespace\r\ndefine_tag(\'fizzle\', -encodenone);\r\n	return(\'bar\');\r\n/define_tag;		\r\n','3877714930','2008-07-06 20:17:34','jason.huck@gmail.com');
